Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# SESSION_CACHED_CURSORS

Property | Description
--- | ---
Parameter type | Integer
Default value | `0`
Modifiable | `ALTER SESSION`
Range of values | 0 to operating system-dependent
Real Application Clusters | Multiple instances can have different values.

`SESSION_CACHED_CURSORS` specifies the number of session cursors to cache. Repeated parse calls of the same SQL statement cause the session cursor for that statement to be moved into the session cursor cache. Subsequent parse calls will find the cursor in the cache and do not need to reopen the cursor. Oracle uses a least recently used algorithm to remove entries in the session cursor cache to make room for new entries when needed.

This parameter also constrains the size of the PL/SQL cursor cache which PL/SQL uses to avoid having to reparse as statements are re-executed by a user.

See Also: Oracle Database Performance Tuning Guide for more information on setting this parameter and its uses